/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : easyoa-pro

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 11/07/2021 02:15:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_accepter
-- ----------------------------
DROP TABLE IF EXISTS `base_accepter`;
CREATE TABLE `base_accepter` (
  `accepter_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) DEFAULT NULL,
  `full_name` varchar(50) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `province_id` int(10) DEFAULT NULL,
  `province_name` varchar(20) DEFAULT NULL,
  `city_id` int(10) DEFAULT NULL,
  `city_name` varchar(50) DEFAULT NULL,
  `district_id` int(10) DEFAULT NULL,
  `district_name` varchar(20) DEFAULT NULL,
  `street` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `is_default` int(1) DEFAULT '0',
  PRIMARY KEY (`accepter_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for base_dept
-- ----------------------------
DROP TABLE IF EXISTS `base_dept`;
CREATE TABLE `base_dept` (
  `dept_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '机构id',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id,0是顶级',
  `dept_name` varchar(200) NOT NULL COMMENT '机构名称',
  `dept_full_name` varchar(200) DEFAULT NULL COMMENT '机构全称',
  `dept_code` varchar(100) DEFAULT NULL COMMENT '机构代码',
  `leader_id` int(11) DEFAULT NULL COMMENT '负责人id',
  `sort_number` int(11) NOT NULL DEFAULT '1' COMMENT '排序号',
  `comments` varchar(400) DEFAULT NULL COMMENT '备注',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除,0否,1是',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `edt_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='组织机构';

-- ----------------------------
-- Records of base_dept
-- ----------------------------
BEGIN;
INSERT INTO `base_dept` VALUES (1, 0, '聚合科技', '云南聚合信息产业有限公司', 'JHKJ', NULL, 1, '', 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (3, 1, '技术部', NULL, NULL, NULL, 3, '', 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (4, 1, '客服部', NULL, NULL, NULL, 4, NULL, 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (5, 1, '电商部', NULL, NULL, NULL, 4, NULL, 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (6, 1, '财务部', NULL, NULL, NULL, 4, NULL, 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (7, 1, '行政部', NULL, NULL, NULL, 4, NULL, 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (8, 3, '研发组', NULL, NULL, NULL, 1, NULL, 0, NULL, NULL);
INSERT INTO `base_dept` VALUES (9, 3, '设计组', NULL, NULL, NULL, 1, NULL, 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_friends
-- ----------------------------
DROP TABLE IF EXISTS `base_friends`;
CREATE TABLE `base_friends` (
  `mid` varchar(32) NOT NULL COMMENT '用户uid',
  `friend_mid` varchar(32) NOT NULL COMMENT '好友uid',
  UNIQUE KEY `uid1` (`mid`,`friend_mid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for base_group
-- ----------------------------
DROP TABLE IF EXISTS `base_group`;
CREATE TABLE `base_group` (
  `gid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '群组id',
  `groupname` varchar(64) NOT NULL COMMENT '群组名称',
  `avatar` varchar(256) NOT NULL DEFAULT 'https://file.airkmg.com/avatar/group.png' COMMENT '群组图标',
  `creator` varchar(32) NOT NULL COMMENT '创建者',
  `add_time` int(11) unsigned NOT NULL COMMENT '创建时间戳',
  PRIMARY KEY (`gid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for base_group_members
-- ----------------------------
DROP TABLE IF EXISTS `base_group_members`;
CREATE TABLE `base_group_members` (
  `gid` int(11) NOT NULL COMMENT '群组id',
  `uid` varchar(32) NOT NULL COMMENT '用户uid',
  UNIQUE KEY `gid` (`gid`,`uid`) USING BTREE,
  UNIQUE KEY `gid_2` (`gid`,`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for base_menu
-- ----------------------------
DROP TABLE IF EXISTS `base_menu`;
CREATE TABLE `base_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id,0是顶级',
  `title` varchar(200) NOT NULL COMMENT '菜单名称',
  `icon` varchar(200) DEFAULT NULL COMMENT '菜单图标',
  `path` varchar(200) DEFAULT NULL COMMENT '菜单路由关键字,目录为空',
  `component` varchar(200) DEFAULT NULL COMMENT '菜单组件地址,目录为空',
  `menu_type` int(11) DEFAULT '0' COMMENT '类型,0菜单,1按钮',
  `sort_number` int(11) NOT NULL DEFAULT '1' COMMENT '排序号',
  `authority` varchar(200) DEFAULT NULL COMMENT '权限标识',
  `target` varchar(200) DEFAULT '_self' COMMENT '打开位置',
  `color` varchar(200) DEFAULT NULL COMMENT '图标颜色',
  `uid` varchar(200) DEFAULT NULL COMMENT '嵌套路由左侧选中',
  `hide` int(11) NOT NULL DEFAULT '0' COMMENT '是否隐藏,0否,1是(仅注册路由不显示左侧菜单)',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除,0否,1是',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `edt_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COMMENT='菜单';

-- ----------------------------
-- Records of base_menu
-- ----------------------------
BEGIN;
INSERT INTO `base_menu` VALUES (1, 0, '工作台', 'el-icon-_component', NULL, NULL, 0, 1, NULL, '_self', NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `base_menu` VALUES (2, 1, '主页', 'el-icon-house', '/dashboard/workplace', NULL, 0, 1, NULL, '_self', NULL, NULL, 0, 0, NULL, 1625761792);
INSERT INTO `base_menu` VALUES (3, 0, '个人中心', 'el-icon-set-up', NULL, NULL, 0, 99, NULL, '_self', NULL, NULL, 0, 0, NULL, 1625797120);
INSERT INTO `base_menu` VALUES (4, 3, '个人信息', 'el-icon-user', '/user/profile', NULL, 0, 1, NULL, '_self', NULL, NULL, 0, 0, NULL, 1625797130);
INSERT INTO `base_menu` VALUES (9, 0, '系统管理', 'el-icon-setting', NULL, NULL, 0, 2, NULL, '_self', NULL, NULL, 0, 0, NULL, NULL);
INSERT INTO `base_menu` VALUES (10, 9, '菜单管理', 'el-icon-_nav', '/system/menu', NULL, 0, 1, NULL, '_self', NULL, NULL, 0, 0, NULL, 1625761823);
INSERT INTO `base_menu` VALUES (11, 9, '用户管理', 'el-icon-_user-group', '/system/user', NULL, 0, 2, NULL, '_self', NULL, NULL, 0, 0, NULL, 1625761841);
INSERT INTO `base_menu` VALUES (12, 9, '角色管理', 'el-icon-postcard', '/system/role', NULL, 0, 3, NULL, '_self', NULL, NULL, 0, 0, 1624981409, 1625797175);
INSERT INTO `base_menu` VALUES (17, 10, '查询', '', '', '', 1, 1, 'sys:menu:lst', '_self', NULL, NULL, 0, 0, 1625687953, NULL);
INSERT INTO `base_menu` VALUES (18, 10, '添加', '', '', '', 1, 1, 'sys:menu:add', '_self', NULL, NULL, 0, 0, 1625687970, NULL);
INSERT INTO `base_menu` VALUES (19, 10, '编辑', '', '', '', 1, 1, 'sys:menu:edt', '_self', NULL, NULL, 0, 0, 1625687987, NULL);
INSERT INTO `base_menu` VALUES (20, 10, '删除', '', '', '', 1, 1, 'sys:menu:del', '_self', NULL, NULL, 0, 0, 1625688009, NULL);
INSERT INTO `base_menu` VALUES (21, 11, '查询', '', '', '', 1, 1, 'sys:user:lst', '_self', NULL, NULL, 0, 0, 1625793841, NULL);
INSERT INTO `base_menu` VALUES (22, 11, '添加', '', '', '', 1, 1, 'sys:user:add', '_self', NULL, NULL, 0, 0, 1625793868, NULL);
INSERT INTO `base_menu` VALUES (23, 11, '编辑', '', '', '', 1, 1, 'sys:user:edt', '_self', NULL, NULL, 0, 0, 1625793881, NULL);
INSERT INTO `base_menu` VALUES (24, 11, '删除', '', '', '', 1, 1, 'sys:user:del', '_self', NULL, NULL, 0, 0, 1625793901, NULL);
INSERT INTO `base_menu` VALUES (25, 12, '查询', '', '', '', 1, 1, 'sys:role:lst', '_self', NULL, NULL, 0, 0, 1625796757, NULL);
INSERT INTO `base_menu` VALUES (26, 12, '添加', '', '', '', 1, 1, 'sys:role:add', '_self', NULL, NULL, 0, 0, 1625796771, NULL);
INSERT INTO `base_menu` VALUES (27, 12, '编辑', '', '', '', 1, 1, 'sys:role:edt', '_self', NULL, NULL, 0, 0, 1625796810, NULL);
INSERT INTO `base_menu` VALUES (28, 12, '删除', '', '', '', 1, 1, 'sys:role:del', '_self', NULL, NULL, 0, 0, 1625796821, NULL);
INSERT INTO `base_menu` VALUES (29, 9, '机构管理', 'el-icon-office-building', '/system/organization', NULL, 0, 4, NULL, '_self', NULL, NULL, 0, 0, 1625797078, NULL);
INSERT INTO `base_menu` VALUES (30, 29, '查询', '', '', '', 1, 1, 'sys:dept:lst', '_self', NULL, NULL, 0, 0, 1625797197, 1625797213);
INSERT INTO `base_menu` VALUES (31, 29, '添加', '', '', '', 1, 1, 'sys:dept:add', '_self', NULL, NULL, 0, 0, 1625797224, NULL);
INSERT INTO `base_menu` VALUES (32, 29, '编辑', '', '', '', 1, 1, 'sys:dept:edt', '_self', NULL, NULL, 0, 0, 1625797240, NULL);
INSERT INTO `base_menu` VALUES (33, 29, '删除', '', '', '', 1, 1, 'sys:dept:del', '_self', NULL, NULL, 0, 0, 1625797254, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_message
-- ----------------------------
DROP TABLE IF EXISTS `base_message`;
CREATE TABLE `base_message` (
  `hid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '消息id',
  `from` varchar(32) NOT NULL COMMENT '发起者uid',
  `to` varchar(32) NOT NULL COMMENT '接收者id，根据type不同，可能是用户uid，可能是群组id',
  `data` text NOT NULL COMMENT '具体的消息数据',
  `type` enum('friend','group') DEFAULT NULL,
  `timestamp` int(11) unsigned NOT NULL COMMENT '消息时间戳',
  PRIMARY KEY (`hid`) USING BTREE,
  KEY `timestamp` (`timestamp`) USING BTREE,
  KEY `from` (`from`) USING BTREE,
  KEY `to` (`to`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for base_position
-- ----------------------------
DROP TABLE IF EXISTS `base_position`;
CREATE TABLE `base_position` (
  `position_id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_id` int(11) DEFAULT NULL,
  `position_name` varchar(50) DEFAULT NULL,
  `position_level` int(11) DEFAULT '0',
  `deleted` int(11) DEFAULT NULL,
  `add_time` int(11) DEFAULT NULL,
  `edt_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`position_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_position
-- ----------------------------
BEGIN;
INSERT INTO `base_position` VALUES (1, 3, 'CTO', 0, NULL, NULL, NULL);
INSERT INTO `base_position` VALUES (2, 3, 'CIO', 0, NULL, NULL, NULL);
INSERT INTO `base_position` VALUES (3, 3, 'SSE', 0, NULL, NULL, NULL);
INSERT INTO `base_position` VALUES (4, 4, '客服', 0, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_role
-- ----------------------------
DROP TABLE IF EXISTS `base_role`;
CREATE TABLE `base_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` varchar(200) NOT NULL COMMENT '角色名称',
  `role_code` varchar(200) DEFAULT NULL COMMENT '角色标识',
  `comments` varchar(400) DEFAULT NULL COMMENT '备注',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除,0否,1是',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `edt_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='角色';

-- ----------------------------
-- Records of base_role
-- ----------------------------
BEGIN;
INSERT INTO `base_role` VALUES (1, '系统管理员', 'sysadmin', '管理员', 0, 1593768783, NULL);
INSERT INTO `base_role` VALUES (2, '管理员', 'admin', '管理员', 0, 1593768783, NULL);
INSERT INTO `base_role` VALUES (3, '游客', 'guest', '游客', 0, 1593768783, NULL);
INSERT INTO `base_role` VALUES (4, '普通用户', 'user', '普通用户', 0, 1625737798, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `base_role_menu`;
CREATE TABLE `base_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `menu_id` int(11) NOT NULL COMMENT '菜单id',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `edt_time` int(11) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK_sys_role_permission_role` (`role_id`) USING BTREE,
  KEY `menu_id` (`menu_id`) USING BTREE,
  CONSTRAINT `base_role_menu_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `base_role` (`role_id`) ON DELETE CASCADE,
  CONSTRAINT `base_role_menu_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `base_menu` (`menu_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限';

-- ----------------------------
-- Records of base_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `base_role_menu` VALUES (1, 2, 1, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (2, 2, 2, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (3, 2, 3, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (4, 2, 4, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (5, 2, 11, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (6, 2, 21, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (7, 2, 22, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (8, 2, 23, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (9, 2, 24, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (10, 2, 12, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (11, 2, 25, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (12, 2, 26, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (13, 2, 27, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (14, 2, 28, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (15, 2, 29, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (16, 2, 30, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (17, 2, 31, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (18, 2, 32, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (19, 2, 33, NULL, NULL);
INSERT INTO `base_role_menu` VALUES (20, 2, 9, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_user
-- ----------------------------
DROP TABLE IF EXISTS `base_user`;
CREATE TABLE `base_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) DEFAULT '0' COMMENT '应用ID',
  `referrer_id` int(11) DEFAULT '0',
  `dept_id` int(11) DEFAULT '0',
  `position_id` int(11) DEFAULT NULL,
  `username` blob,
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `avatar` varchar(255) DEFAULT 'https://file.airkmg.com/avatar/default_member_logo.png' COMMENT '头像地址',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机',
  `sex` int(1) DEFAULT NULL COMMENT '性别',
  `realname` varchar(20) DEFAULT NULL COMMENT '真实姓名',
  `credentials_type` varchar(10) DEFAULT NULL,
  `credentials_name` varchar(20) DEFAULT NULL,
  `credentials_number` varchar(20) DEFAULT NULL,
  `credentials_expiry` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL COMMENT 'email账号',
  `qq` varchar(20) DEFAULT NULL COMMENT 'QQ账号',
  `sign` varchar(255) DEFAULT NULL COMMENT '签名',
  `app_share_img` varchar(255) DEFAULT NULL,
  `xcx_share_img` varchar(255) DEFAULT NULL,
  `balance` decimal(11,2) DEFAULT '0.00' COMMENT '余额',
  `integral` decimal(11,2) DEFAULT '0.00' COMMENT '积分',
  `wechat_union_id` varchar(50) DEFAULT NULL,
  `apple_openid` varchar(50) DEFAULT NULL COMMENT '苹果用户唯一标识符',
  `app_version` varchar(10) DEFAULT NULL,
  `wgt_version` varchar(10) DEFAULT NULL,
  `device_platform` varchar(10) DEFAULT NULL,
  `device_clientid` varchar(100) DEFAULT NULL,
  `device_token` varchar(100) DEFAULT NULL,
  `last_longitude` varchar(50) DEFAULT NULL,
  `last_latitude` varchar(50) DEFAULT NULL,
  `last_login_ip` varchar(20) DEFAULT NULL COMMENT '最后登录IP',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `last_login_timestamp` int(11) DEFAULT NULL COMMENT '最后登录时间',
  `update_timestamp` int(11) DEFAULT NULL COMMENT '更新时间',
  `logout_timestamp` int(11) DEFAULT NULL COMMENT '退出时间',
  `notice_read_timestamp` int(11) DEFAULT NULL COMMENT '最后阅读消息时间',
  `useable` int(1) DEFAULT '1' COMMENT '可用状态',
  `deleted` int(1) DEFAULT '0',
  `online_status` enum('online','offline') DEFAULT 'offline' COMMENT '在线状态',
  `app_online_status` enum('online','offline') DEFAULT 'offline' COMMENT '在线状态',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `mobile` (`mobile`) USING BTREE,
  KEY `position_id` (`position_id`) USING BTREE,
  KEY `base_user_ibfk_2` (`dept_id`) USING BTREE,
  CONSTRAINT `base_user_ibfk_1` FOREIGN KEY (`position_id`) REFERENCES `base_position` (`position_id`),
  CONSTRAINT `base_user_ibfk_2` FOREIGN KEY (`dept_id`) REFERENCES `base_dept` (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10011 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_user
-- ----------------------------
BEGIN;
INSERT INTO `base_user` VALUES (10005, 1, 0, 3, 1, 0x796F6E63726F6E, '4297f44b13955235245b2497399d7a93', 'http://file.airkmg.com/avatar/10005', '18669099310', 1, '羊某某', 'NI', '身份证', '510722198803042750', '2040-01-14', 'ykl2f@126.com', '154759420', '海纳百川，有容乃大。', NULL, NULL, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1593768783, NULL, 1625939578, 1625940946, NULL, 1, 0, 'online', 'online');
INSERT INTO `base_user` VALUES (10006, 1, 0, 3, 3, 0x687569, '4297f44b13955235245b2497399d7a93', 'https://file.airkmg.com/avatar/default_member_logo.png', NULL, 1, '刘某某', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1593768783, NULL, 1625939902, 1625939638, NULL, 1, 0, 'offline', 'offline');
INSERT INTO `base_user` VALUES (10008, 1, 0, 3, NULL, 0x68616E, '4297f44b13955235245b2497399d7a93', 'https://file.airkmg.com/avatar/default_member_logo.png', NULL, 1, '张某某', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1593768783, NULL, 1625939672, 1593768783, NULL, 1, 0, 'offline', 'offline');
COMMIT;

-- ----------------------------
-- Table structure for base_user_role
-- ----------------------------
DROP TABLE IF EXISTS `base_user_role`;
CREATE TABLE `base_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色';

-- ----------------------------
-- Records of base_user_role
-- ----------------------------
BEGIN;
INSERT INTO `base_user_role` VALUES (40, 10005, 1, 1625939578);
INSERT INTO `base_user_role` VALUES (45, 10008, 4, 1625939672);
INSERT INTO `base_user_role` VALUES (46, 10006, 4, 1625939902);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
